<%@ page import="java.util.List" %>
<%@ page import="java.util.ArrayList" %>
<%@ page import="java.sql.Connection" %>
<%@ page import="java.sql.Statement" %>
<%@ page import="java.sql.ResultSet" %>
<%@ page import="java.sql.DriverManager" %><%--
  Created by IntelliJ IDEA.
  User: 123
  Date: 2018/4/3
  Time: 15:55
  To change this template use File | Settings | File Templates.
--%>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html>
<head>
    <title>用户列表</title>

    <style type="text/css">
        table {
            border: 1px solid black;
            border-collapse: collapse;
        }

        td, tr {
            border: 1px solid red;
            padding: 10px;
        }

    </style>
</head>
<body>
<table>
    <tr>
        <td>编号</td>
        <td>用户名</td>
        <td>密码</td>
        <td>编辑信息</td>
        <td>删除信息</td>
    </tr>


    <%
        class User {
            int id;
            String username;
            String password;

            public User(int id, String username, String password) {
                this.id = id;
                this.username = username;
                this.password = password;
            }
        }


        List<User> userList = new ArrayList<>();

//    User chen=new User();
//
//    chen.id=1;
//    chen.username="chen";
//    chen.password="123";
//    userList.add(chen);
//
//    User john=new User();
//    john.id=2;
//    john.username="john";
//    john.password="456";
//    userList.add(john);


        Connection connection = null;
        Statement statement = null;
        ResultSet resultSet = null;


        String sql = "select * from t_users_1";

        Class.forName("com.mysql.cj.jdbc.Driver");

        connection = DriverManager.getConnection("jdbc:mysql://localhost:3306/sctu_javaweb_2018?useUnicode=true&useJDBCCompliantTimezoneShift=true&useLegacyDatetimeCode=false&serverTimezone=UTC",
                "root",
                "123456");

        statement = connection.createStatement();
        resultSet = statement.executeQuery(sql);

        while (resultSet.next()) {
            int id = resultSet.getInt(1);
            String username = resultSet.getString(2);
            String password = resultSet.getString(3);


            User user = new User(id, username, password);
            userList.add(user);
        }


        resultSet.close();
        statement.close();
        connection.close();

        for (User user : userList){

            //221替换原则
            out.write("<tr><td>"+user.id+"</td>" +
                    "<td>"+user.username+"</td>" +
                    "<td>"+user.password+"</td>" +
                    "<td><a href='updateUser.jsp?id="+user.id+"" +
                    "&username="+user.username+"" +
                    "&password="+user.password+"'>更新</a></td>" +
                    "<td><a href='deleteUser.jsp?id="+user.id+"'>删除</a></td>");
        }


    %>
</table>
</body>
</html>
